This Article describes how to create a Microsoft SQL Server Agent job step that executes Store procedure in SQL Server    by using SQL Server Management Studio.

 following the below steps

Step- 1

 right Click on jobs => New Job

Step-2

write  Job Name  My_Job  and job description.

Step-3

Click On Step Button

Step-4

Click on  New Button

Step-5

Write Step name and choose database name and write store procedure in command text box. after click to ok button.

Step-6

Click on Schedules button

Step -7

Click to new button Create New Schedules

Step- 8

Write Schedule name and set execution timing when you want to execute Job Scheduler.

and click to ok button.

Step-9

click to ok button complete your job scheduler creation process

Step-10

Click on your job name which you have created.

Right click on your job name which you have created. and click on Start job at step.

Step-11

Here your have done complete Job Creation process  . click to Close button

I hope this article help full for you.